package com.building.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.building.entity.Engineering;
import java.util.List;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

/**
@author yinjiahui
@create 2021-04-07 19:22
*/
@Mapper
public interface EngineeringMapper extends BaseMapper<Engineering> {
    int updateBatch(List<Engineering> list);

    int updateBatchSelective(List<Engineering> list);

    int batchInsert(@Param("list") List<Engineering> list);

    int insertOrUpdate(Engineering record);

    int insertOrUpdateSelective(Engineering record);



    /**
     * 查询所有数据  加 分页
     * @param limit
     * @param page
     * @return
     */
//    @Select("SELECT * FROM `material_engineering` t1 left JOIN material_engineering_stage t2 on t1.engineering_stage_id = t2.engineering_stage_id LEFT JOIN material_engineering_type t3 on t1.engineering_type_id = t3.engineering_type_id where t1.is_del = 0 LIMIT #{limit},#{page} ")
//    List<Engineering> selectEngineering(@Param("limit") Integer limit, @Param("page") Integer page);



}